# -*- encoding:utf-8 -*-
import openpyxl
import os
import re
from pathlib import Path

from openpyxl import Workbook
from openpyxl.drawing.image import Image
from openpyxl.utils import get_column_letter
from PIL import Image as PILImage

workbook1 = openpyxl.load_workbook('C:\\Users\\VV\\Desktop\\5555\\export.xlsx')
sheet1 = workbook1['Sheet1']

for row in sheet1.iter_rows(min_row=10, min_col=5, max_row=2313, max_col=5):
    cell_value = row[0].value
    #print(cell_value)
    str = cell_value[:-1]
    sheet1.cell(row=row[0].row, column=5).value = str



workbook1.save('C:\\Users\\VV\\Desktop\\5555\\export2.xlsx')
workbook1.close()